When I call the method getTableTypes() in java.sql.DatabaseMetaData,
all that's returned is:
SYSTEM INDEX.
The code for org.posgresql.DatabaseMetaData suggest that I should get at least
/** * Get the table types available in this database. The results * are ordered by table type. * * <P>The
tabletype is: * <OL> * <LI><B>TABLE_TYPE</B> String => table type. Typical types are "TABLE", *
"VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", * "LOCAL TEMPORARY", "ALIAS", "SYNONYM". * </OL> * *
@returnResultSet each row has a single String column that is a * table type */
but not the one (only) I get returned
snip:
java.sql.ResultSet rs = dbmd.getTableTypes ();
while (rs.next()) System.out.println(rs.getString(1));
just to rule out a codeing problem
--
Simu Soft
v/Anders Svensson
Nørrebrogade 140, 4 th
2200 København N
e-mail : Anders@simusoft.dk
tlf. : +45 3583 8126